﻿using System;
using System.Data;
using System.Collections.Generic;

using Com.Framework.Data;
using Com.Library.DB;

namespace Com.Library.DB.Advertise
{
	internal class AdvertiseCreate : DBDataReader<DataEntity, DataEntity>
	{
		public AdvertiseCreate()
			: base(new ConnectionString(), "TSP_Advertise_Create")
		{
		}

		protected override void ParameterInitialize()
		{
			AddParameter("n4CategoryNo", SqlDbType.Int, 4, SqlDataInOut.Input);
			AddParameter("strTitle", SqlDbType.NVarChar, 200, SqlDataInOut.Input);
			AddParameter("strListTitle", SqlDbType.NVarChar, 200, SqlDataInOut.Input);
			AddParameter("strContent", SqlDbType.NVarChar, 4000, SqlDataInOut.Input);
			AddParameter("strLink", SqlDbType.VarChar, 300, SqlDataInOut.Input);
			AddParameter("strImageURL", SqlDbType.VarChar, 200, SqlDataInOut.Input);
			AddParameter("strThumbURL", SqlDbType.VarChar, 200, SqlDataInOut.Input);
			AddParameter("n1MoveType", SqlDbType.TinyInt, 1, SqlDataInOut.Input);
			AddParameter("strMovieURL", SqlDbType.VarChar, 300, SqlDataInOut.Input);
			AddParameter("strHTML", SqlDbType.VarChar, 1000, SqlDataInOut.Input);
			AddParameter("strFlashURL", SqlDbType.VarChar, 300, SqlDataInOut.Input);
			AddParameter("strManagerName", SqlDbType.NVarChar, 100, SqlDataInOut.Input);

			AddParameter("strImage2URL", SqlDbType.VarChar, 200, SqlDataInOut.Input);
			AddParameter("strImage3URL", SqlDbType.VarChar, 200, SqlDataInOut.Input);
			AddParameter("strImage4URL", SqlDbType.VarChar, 200, SqlDataInOut.Input);
			AddParameter("strImage5URL", SqlDbType.VarChar, 200, SqlDataInOut.Input);
		}
	}
}